How to: Display worksheets in separate windows.
Solution:
Activate the workbook containing the sheets, select 'New Window' from the 'Window' menu, and click the corresponding sheet tab to activate the worksheet in the window.
1) Activate the workbook containing the worksheets that will be displayed in separate windows.
2) Select the 'Window' menu and select 'New Window'.
NOTE: Repeat this one time for each additional worksheet to be seen. This opens a new window onto the workbook each time.
3) Press CTRL+PGUP and/or CTRL+PGDN to activate the worksheet in the window and repeat for other worksheets.
